Oracle APEX

Very fast database level applications
Applications where reports and forms are there
Getting data from various sources like cloud

APEX is very well fit for solving fast some day to day activities in every organization.

The most suitable case for Oracle Application Express is any application, web desktop or mobile, that only needs to store and manipulate data in Oracle Database, and be accessed online all the time.

Other than that, avoid Oracle Application Express (e.g., apps which rely heavily to Javascript functionality, apps to analyze Twitter data, apps which need to manipulate OS files, apps to create complex and static reports).

Oracle Application Express is good for easy and fast application and reports development. You can develop entire applications and you do not need another web server. However, you cannot access the source code of applications built in Oracle Application Express.

I would definitively use APEX for small (department size) applications that can be developed and maintained by a small development team, without a complex design/develop/test/deploy process.
Also, to generate all basic CRUD on complex applications, rather than programming them using other languages (Java. c#, etc) and having more complex deployment processes.

Best for web applications. Less appropriate, however, for mobile applications. Applications that deal with businesses are quite useful.

Capturing data and uploading documents. Easy design for the template.

It is appropriate for database application development supporting data driven processes, online transaction processing, BI/reports/analytics ... for addressing about any business data processing need I can think of. Oracle Application Express is fantastic for creating beautiful rich user interfaces with support for all major browsers rendering well on a range of devices. It is less appropriate for applications requiring native low level access to device peripherals and is less appropriate for applications that must execute offline without network/internet connection to supporting application and database servers.

APEX is data-centric. When you have a data-driven company with large data flows, APEX is a great choice. Because APEX is installed directly in the database, the data is always available. The Universal Theme allows you to make responsive applications without the need to write extra code. So users can access the data even their phones/tablets when they're on location. Applications build with APEX are most of the times multi-page applications. Today single-page applications (SSA) are more popular. Building an SSA can be quite difficult with APEX.

Oracle Application Express can essentially be used for any web application that needs to talk to an Oracle Database. Simple applications to view/edit data can be turned out in next to no time with the built-in reports allowing fine-grained control for the end user. It really shines when used for tasks such as dashboard management or basic manipulation of data, all of which can be done with next to no code.

For less standardized tasks, the architecture will allow the use of other web technologies. I have, for instance, incorporated Google Maps into Oracle Application Express in order to visually show data, such as the operating areas, for our consultants. Setting this up in the Application Express framework is relatively straightforward allowing me to concentrate on the heavy lifting in PL/SQL.

The only major area I've found that it isn't well suited in currently is outputting anything printable, typically requiring the use of some 3rd party hardware or Oracle BI (if money is no object). I have also run into issues when working with larger teams as it doesn't lend itself well to source control with all the pages being stored in the database itself.

Almost any business requirement with data-centric aspects can be covered - no limitations.
ERP, CRM, HCM, Financials, mobile apps.

In our scenario, I think it is the best instrument for data correction and data validation.

Oracle Application Express is well suited if you have a big dataset which has to be visualized in a graphic manner or if you have to provide a good solution to create, edit or manipulate data by end-users in a web-application. It is also well suited if you need to create KPIs that might already be in place and they just have to be brought to the surface in the browser!

It is very good when you have an application like Forms and need additional functionality (features) that you can't have in forms (dashboards, predefined IR with charts). It's a good use of external sources (web sources, REST API) and ata visualization. I haven't tried it yet, but I don't know how it functions in complex pages (a lot of client controls, few hundred fields). For example, we have physician reports or discharge summaries, and nurse documentation about the care of a patient.

It's well suited if you need to display (or enter/change) data from an Oracle database. If you (or your customer) think you definitely need a native app, then it is not a good fit. Creating a dashboard with different kinds of charts and KPI's is easy using APEX. If you need a real data-mining solution, then you better switch to Oracle Analytics. As APEX offers an easy interface for RESTful services, you can also create forms, reports, and charts upon any RESTful service that's available on the internet -- either within or outside your organization.

I feel like this system works well for most lines of business. It may not work well for organizations that only have a few people, but it is great when your organization is larger and/or spread out across multiple states. It allows for team members to have networking in that aspect.

Oracle APEX is a Versatile tool. Though it is database specific, it can be used with many other different technologies. Also, it is accessible from browser as well as mobile.

It is a nice and inexpensive tool, ideal to extend the functionality of the systems, and offer users good reports, graphics and easy-to-use applications, developed with speed and low maintenance cost. We don’t use it when we have to customize standard processes in our ERP, mainly because we are SOX compliant, and it is more difficult to us to prove our auditors that we respect and accomplish with all the validations and controls they demand.

I would recommend it completely if you need the production of functional sites quickly. Simple approvals flow through different hierarchical levels can be simulated through groups and roles, but if the need is more complex flows for robust systems, I would advise opting for other programming frameworks.

If you use Oracle Database and want to create an application that uses your data, this is a free development tool and it's amazing what it can do.

Oracle Application Express is best suited for web applications that are data-driven, requires high reliability and intended to be scalable.

We needed an app system pronto and so with our switch to Oracle it worked out perfectly for us. We had been developing our database systems beforehand and so we were ready for the roll out without having to add any additional time or stress. APEX would not be well suited to any company that is not wholly committed to Oracle, though.

Well suited for small teams of developers for very small applications Also good to prototype using this tool and moving to another one that has cross platform and vendor support. It is included with ORACLE RDBMS so no additional costs or licensing required to use the product. It is scalable from PCs to RAC systems.

This is well suited for order entry, displaying information on mobile devices, getting prototype applications up quickly, and more. Reports are rather robust too and again easy to assemble and put up. APEX is wizard-based or you can open the app and make your changes via the web environment as well. It is best for working over the web, collecting information and displaying information.

If there is a time limit and more security is required one should go with it as it provides locking functionality to prevent a deadlock situation.